Appendix B – Auto-populated Formulae

Auto-populated Value

A standard ADO style connection string.  This can be used in the report to fire ad-hoc queries from formula.   Use of this is not recommended, and it is included for backward-compatibility only.

Code:

Database.FormatChar(Database.ConnectionDetails)

The username of the user executing the report.

Code:

Database.FormatChar(Database.JiwaLoginUserName)

The contents of the “CompanyName” system setting.

Code:

Database.FormatChar(Database.ReadSysData("System", "CompanyName", "Jiwa Financials"))

The contents of the “CompanyPhone” system setting.

Code:

Database.FormatChar(Database.ReadSysData("System", "CompanyPhone", "Jiwa Financials"))

The contents of the “CompanyFax” system setting.

Code:

Database.FormatChar(Database.ReadSysData("System", "CompanyFax", "Jiwa Financials"))

The contents of the “CompanyAddress1” system setting.

Code:

Database.FormatChar(Database.ReadSysData("System", "CompanyAddress1", "Jiwa Financials"))

The contents of the “CompanyAddress2” system setting.

Code:

Database.FormatChar(Database.ReadSysData("System", "CompanyAddress2", "Jiwa Financials"))

The contents of the “CompanyAddress3” system setting.

Code:

Database.FormatChar(Database.ReadSysData("System", "CompanyAddress3", "Jiwa Financials"))

The contents of the “CompanyAddress4” system setting.

Code:

Database.FormatChar(Database.ReadSysData("System", "CompanyAddress4", "Jiwa Financials"))

The contents of the “CompanyEmail” system setting.

Code:

Database.FormatChar(Database.ReadSysData("System", "CompanyEmail", "Jiwa Financials"))

The contents of the “CompanyWebsite” system setting.

Code:

Database.FormatChar(Database.ReadSysData("System", "CompanyWebsite", "Jiwa Financials"))

The contents of the “CompanyACN” system setting.

Code:

Database.FormatChar(Database.ReadSysData("System", "CompanyACN", "Jiwa Financials"))

The current date as per the Jiwa (i.e. A user is able to login under a different date – it is this date that is used).  This is the date that appears on the bottom right of the Jiwa status bar, and can be changed by the user.

Code:

Trim$("Date(" & Format$(Database.SysDate, "yyyy") & ", " & Format$(Database.SysDate, "mm") & ", " & Format$(Database.SysDate, "dd") & ")")

The current time as per the Jiwa (i.e. A user is able to login under a different time – it is this time that is used).  This is the time that appears on the bottom right of the Jiwa status bar, and can be changed by the user.

Code:

Trim$("Date(" & Format$(Database.SysDate, "yyyy") & ", " & Format$(Database.SysDate, "mm") & ", " & Format$(Database.SysDate, "dd") & ")")

This is the current date as per the user’s machine.

Code:

Trim$("Date(" & Format$(Date, "yyyy") & ", " & Format$(Date, "mm") & ", " & Format$(Date, "dd") & ")")

This is the current time as per the user’s machine.

Code:

Database.FormatChar(Format$(Date, "Long Date"))